Installing SequeLink® Server on Linux and UNIX

NOTE: See "SequeLink® Server" for database prerequisites.

The method you use to install SequeLink Server for Linux and UNIX depends on whether you install:

Table 2-7 identifies the SequeLink Server tar file you need to transfer for your SequeLink Server.

Table 2-7. SequeLink Server tar Files
SequeLink Server
32-bit Tar Files
64-bit Tar Files
DB2
sldb2.tar
sldb264.tar
Informix
slinf.tar
N/A
JDBC Socket
slsoc2jdbc.tar
N/A
ODBC Socket
slsoc.tar
slsoc64.tar
Oracle
slora.tar
slora64.tar
Sybase
slsyb.tar
slsyb64.tar

Installation Setup Notes

The following sections describe utilities and procedures that an administrator can use during installation and setup of SequeLink Server:

User Login for Installation

To install SequeLink Server, you can log on as root or another user. If you choose to log on as any user other than root, the security operating system user ID and password authentication mechanism (for example, ServiceAdminAuthMethods=OSlogon(UID,PWD)) will not be supported for this SequeLink installation. For more information about authentication and defining security for SequeLink, refer to the SequeLink Administrator's Guide.

Processor Information Utility

DataDirect Technologies Support may, on occasion, ask that you use the Processor Information Utility to identify the type of license you need.

After you have untarred the SequeLink Server package, execute from a command shell: ddprocinfo.

The utility automatically determines the number and type of processors in your machine and displays the information. The message also includes the type of license required for your DataDirect Technologies product. Provide this information to DataDirect Support when requested.

Checking Your Third-Party JDBC Driver Environment

The ivcheckjdbcdriver utility is unpackaged after you extract the contents of the SequeLink Server for JDBC Socket.tar file. The SequeLink administrator can use the ivcheckjdbcdriver utility to check the third-party JDBC driver environment that will be used behind the SequeLink Server for JDBC Socket.

Gathering Information for the Installation

Table 2-8 lists the information that you must supply during installation of all SequeLink Servers on Linux/UNIX. The table also provides an example of a value for each attribute.

Table 2-8. Required Information for All SequeLink Server Installations on Linux and UNIX 
Attribute
Example
SequeLink Service Attribute
Installation directory
/usr/slserver60
N/A
SequeLink Administrator Name
root
"ServiceAdministrator"
Name for SequeLink Agent
SLAgent60
"ServiceName"
Port for SequeLink Agent
19995
"ServiceConnectInfo"
Name for SequeLink Server
SLOracle60
"ServiceName"
Port for SequeLink Server
19996
"ServiceConnectInfo"
Name
Sales
N/A
Company
CompanyXYZ
N/A
Serial Number
1
N/A
IPE Key
*
N/A

1NOTE: Provided by DataDirect Technologies for registered users

SequeLink® Server for DB2

During installation of SequeLink Server for DB2 on Linux and UNIX, you must supply the UNIX account name of the DB2 instance, for example, db2inst1.

SequeLink® Server for Informix

During installation of SequeLink Server for Informix on Linux and UNIX, you must supply the INFORMIXSERVER attribute, for example, myInformixServer. You set this value with the "DataSourceINFInformixServer" service attribute, described in the SequeLink Administrator's Guide.

SequeLink® Server for JDBC Socket

Table 2-9 lists the information that you must supply during installation of SequeLink Server for JDBC Socket on Linux and UNIX. The table also provides an example of a value for each attribute.

Table 2-9. Required Information for SequeLink 6.0 Server for JDBC Socket on UNIX 
Attribute
Example
SequeLink Service Attribute
J2RE Path
Required
/usr/bin/java
"ServiceEnvironmentVariable" for the shared library path
Driver ClassPath
/usr/slserver60/bin/classes;/ JDBCDrivers/Drivers.jar
"ServiceEnvironmentVariable"
CLASSPATH
Driver ClassName
com.ddtek.jdbc.derby10.DerbyDriver
"DataSourceSOCJDBCDriverClassName"
Connection URL
jdbc:dd-derby10
"DataSourceSOCJDBCConnectionURL"
Database Properties
derby10
"DataSourceSOCJDBCDbProperties Name"

SequeLink® Server for ODBC Socket

During installation of SequeLink Server for ODBC Socket on Linux and UNIX, you can supply a connection string for a backend ODBC data source, for example, DSN=my_backend_ODBC_ds.

To set this value, use the "DataSourceSOCODBCConnStr" service attribute, described in the SequeLink Administrator's Guide.

SequeLink® Server for Oracle

Table 2-10 lists the information that you must supply during installation of SequeLink Server for Oracle on Linux and UNIX. The table also provides an example of a value for each attribute.

Table 2-10. Information Used During Installation of SequeLink 6.0 Server for Oracle on Linux and UNIX
Attribute
Example
SequeLink Service Attribute
UNIX account name of the Oracle instance
Required
ora10
N/A
Connection method
  • An Oracle SQL*Net Service such as ORA10TCP
  • Bequeath protocol using Oracle SID, such as ORA10
"DataSourceORAServiceName"
ORACLE_HOME
/rdbms/oracle10g
N/A
ORACLE_SID
ORCL
N/A

SequeLink® Server for Sybase

Table 2-11 lists the information that you may supply during installation of SequeLink Server for Sybase on Linux and UNIX. The table also provides an example of a value for each attribute.

Table 2-11. Information Used During Installation of SequeLink 6.0 Server for Sybase on Linux and UNIX
Attribute
Example
Service Attribute Used
UNIX account name of the Sybase instance
Required
syb15
N/A
Home directory of the Sybase account
/rdbms/syb15
N/A
Name of the Sybase server
mySybaseServer
"DataSourceSybNetworkAddress"

Installing on a Server with a DVD-ROM Drive

If your Linux or UNIX server has a DVD-ROM drive, you can install SequeLink Server from the DataDirect DVD. When the installation completes, the Installer window appears, allowing you to install another product or exit from the installer. Default answers for any questions are displayed in square brackets, [ ]. To accept the default, press ENTER.

When you run the SequeLink Server installer, it prompts you for choices you need to make and information you need to supply. Default answers to questions are enclosed within square brackets, [ ]. To accept the default, press ENTER.

NOTES:

To install SequeLink Server:

  1. Log on to your UNIX system as root. See "User Login for Installation" for more information.

    2. NOTE: If you are installing SequeLink Server for JDBC Socket, you must log on with root authority.

  2. Mount the DVD. See "Mounting Your DVD" for instructions on mounting the DVD.
  3. Change to the top-level directory on the DVD and navigate to the product package that you want to install. For example, for Oracle on UNIX, the directory structure is one of the following:

    4. sl60/solaris/server/32-bit/slora.tar

    sl60/solaris/server/64-bit/slora64.tar

  4. Untar the package. For example, for the 32-bit Oracle package, enter the following command:

    5. tar -xvof slora.tar

  5. Enter the following command:

    6. ksh install.sh

  6. Select the SequeLink Server to install.
  7. Verify the SequeLink Server to install (the examples in this procedure show the information that displays when you install SequeLink Server for Oracle on a 32-bit machine).

    8. You are installing the product:

    SequeLink 6.0 Server for Oracle 9 or 10

    on Solaris 10 or higher

    -----------------------------------------------

    Do you want to continue (Y/N) ? [Y]

    Enter Y to continue the installation. Enter N to stop the installation; no software is installed.

  8. Enter the installation directory, or press ENTER to accept the default installation directory. If the directory does not exist, it will be created for you.
  9. Enter the UNIX account name that was used to install the database software on your machine.
  10. Select the connection method that you want SequeLink to use to connect to the Oracle Server.

    11. Please choose the connection method you want SequeLink to use to connect to the Oracle server.

    1. Bequeath Protocol

    2. Oracle Net Service: connect to the Oracle database

    through the Oracle listener.

    Enter your choice [1]:

    The default is to use the Oracle Bequeath Protocol to communicate to the Oracle database engine. However, we strongly recommend that during installation, you select the Oracle Net Service instead. If you accept the default value during installation and later want to use the Oracle Net Service, you can change the configuration.

  11. You are prompted to confirm information about your database installation. Enter the information for which you are prompted, or press ENTER to accept the proposed values.

    12. The installer accessed your current Oracle

    installation and found a list of possible values for the environment variable ORACLE_SID.

    Please enter the value for the environment variable

    ORACLE_SID applicable to your Oracle installation.

    ora10g

    Please enter a value for the ORACLE_SID variable [ora10g]: ora10g

    ***********************************************

  12. You are prompted for information that is required to create the SequeLink Agent. The SequeLink Agent allows the SequeLink administrator to configure, manage, and monitor this SequeLink Server using the SequeLink Manager. To create a SequeLink Agent service, enter the user ID of the SequeLink administrator account, or press ENTER to accept the default.

    13. Please enter the Unix account name which will be allowed to remotely administer this SequeLink Server [root] :

  13. Enter the name of the SequeLink Agent service, or press ENTER to accept the default.

    14. Enter the name of this SequeLink agent service [SLAgent]:

  14. Enter the TCP/IP port that the SequeLink Agent service will use to listen for connection requests.

    15. Enter the TCP/IP port for your SequeLink agent service [19995] :

    Enter an available unique port, or press ENTER to accept the default. The installer creates the SequeLink Agent.

    NOTE: The port you choose must be unique (not used by another service). If the port you choose is not unique, the installation will fail. No software will be installed.

  15. Enter the name of the SequeLink data access service, or press ENTER to accept the default.

    16. Enter the name of your SequeLink Oracle service [SLOracle10] :

  16. Enter the TCP/IP port that the SequeLink Server will use to listen for connection requests.

    17. Enter the TCP/IP port for this SequeLink Oracle service [19996] :

    Enter an available port, or press ENTER to accept the default. The port you choose must not be used by another service. The installer creates the SequeLink data access service.

  17. Review the installation settings.

    18. Ready to start installation with the following settings:

    SequeLink home directory : ../slserver60

    SequeLink Agent settings: Administrator : root

    Service name : SLAgent

    TCP/IP port: 19995

    SequeLink Oracle settings : Service name : SLOracle

    TCP/IP port : 19996

    Oracle home directory : /rdbms/oracle10g

    ORACLE_SID : ora10g

    Link service executables : No

    You will need approx. 40000 kBytes free diskspace in your SequeLink home directory (depending on your platform and configuration).

    -----------------------------------------------

    1) Start installation with these settings

    2) Change SequeLink home directory

    3) Change SequeLink Agent settings

    4) Change SequeLink Oracle settings

    5) Change Oracle home directory

    6) Change Oracle version

    7) Change Oracle Connection method

    9) Abort installation

    Enter your choice [1] ?

    You can choose to continue with the installation using these settings, change any settings, or end the installation. Enter the appropriate choice, or press ENTER to start the installation with the current settings.

  18. You are prompted for your product registration. Enter your name, company name, serial number, and key. The serial number and key are provided to you by DataDirect Technologies. If you are installing an evaluation copy of SequeLink Server, leave the Key field empty.
  19. The installer prompts you to review the information. Enter C to change the information, or press ENTER to continue.
  20. The license agreement is displayed. Press ENTER to advance through the license agreement. Then, enter YES to accept the license agreement or NO to decline the agreement and end the installation.
  21. The installer prompts you to continue with the installation. Press ENTER to continue. The installer installs the files.
  22. When the installation of the SequeLink Agent is complete, the installer prompts you to start the SequeLink Agent service.

    23. -----------------------------------------------

    Starting SequeLink Agent service

    -----------------------------------------------

    Would you like the installer to start the SequeLink Agent (Y/N) ? [Y]

    Enter Y to start the SequeLink Agent service. Enter N if you do not want to start the SequeLink Agent service at this time. You can start the SequeLink Agent at a later time.

  23. The installer prompts you to start the SequeLink Server data access service.

    24. Would you like the installer to start SequeLink Server for Oracle (Y/N) ? [Y]

    Enter Y to start the SequeLink Server data access service. Enter N if you do not want to start the service at this time. You can start the SequeLink service at a later time.

  24. The installer prompts you for the password for the user ID that you specified in Step 12.

    25. Password:

    Enter the password of the SequeLink administrator account. A message appears when SequeLink Server successfully starts and publishes itself on the TCP/IP port.

You may need to tune your SequeLink Server after installation. For information on tuning the SequeLink Server, refer to the SequeLink Administration Guide.

Installing on a Server without a DVD-ROM Drive

Installing SequeLink Server when your server does not have a DVD-ROM drive involves:

If you logged on to your Linux or UNIX system as a user other than root, extract the files from the SequeLink Server tar file and then, execute the ksh install.sh -po command as described in this section.

If your server does not have a DVD-ROM drive, you can mount a DVD on another computer with a DVD-ROM drive and transfer the tar file in binary format to your server using file transfer software (for example, FTP). After the tar file is transferred or copied to your server, you must extract the files from the tar file to run the installation script.

Table 2-7 "SequeLink Server tar Files" identifies the SequeLink Server tar file you need to transfer for your SequeLink Server.

Transferring SequeLink Server Files

  1. Mount the DVD on a computer with a DVD-ROM drive and FTP capability. See "Mounting Your DVD" for instructions on mounting the DVD.
  2. Log on to your UNIX system as root or another user. See "User Login for Installation" for more information.
  3. If a SequeLink home directory does not exist, create a target directory on the server. For example, to create a SequeLink home directory called sqlnk in the usr directory, enter:

    4. mkdir /usr/sqlnk

  4. On the machine from which you will be transferring the files, change to the directory on the DVD for your server platform (for example, /sqlnk60/solaris/server).

    5. From this machine, transfer the appropriate tar file (in binary format) to the SequeLink home directory on the server (for example, /usr/sqlnk).

    How you transfer files from another system to the server depends on your TCP/IP product and your system's operating system. For more information about transferring files, refer to the documentation supplied with your TCP/IP product.

    IMPORTANT: Transfer the tar file in binary format. If you transfer files in the wrong format, the SequeLink Server installation will fail.

Extracting SequeLink® Server Files

On the server, access the tar file you transferred to the SequeLink home directory and extract it. For example, to extract the tar file for SequeLink Server for Oracle, you would enter: 

tar -xvof slora.tar

Running the Installation Script

When you run the installation script, it prompts you for choices you need to make and information you need to supply. Default answers to questions are enclosed within square brackets, [ ]. To accept the default, press ENTER.

NOTE: The examples in this procedure show the information that displays when you install SequeLink Server for Oracle. See "Installing SequeLink® Server" for a description of the installation options used in the other SequeLink Servers.

To run the installation script:

  1. Change to the SequeLink home directory. For example, enter:

    2. dvd /usr/sqlnk

  2. If you logged on to your UNIX system as:
    • root, enter the following command:

      • ksh install.sh

    • Another user, enter the following command:

      • ksh install.sh -po

  3. Select the SequeLink Server to install.
  4. Follow Step 7 through Step 24 under "Installing on a Server with a DVD-ROM Drive" to complete the installation.

Installing From Downloaded Files

The tar file you download from the DataDirect Technologies Web site depends on the SequeLink Server you are using. Table 2-7 "SequeLink Server tar Files" identifies which SequeLink Server tar file to download.

NOTE: The examples in this procedure show the information that displays when you install SequeLink Server for Oracle on UNIX. See "Installing SequeLink® Server" for a description of the installation options used in the other SequeLink Servers.

To install SequeLink Server from files downloaded from the Web:

  1. Log on to your UNIX system as root or another user. See "User Login for Installation" for more information.
  2. Download the SequeLink Server tar file from the DataDirect Technologies Web site. Download instructions are available on the DataDirect Technologies Web site.

    3. If you are downloading to a machine other than the target machine, you will need to transfer the file (in binary format) to your UNIX workstation. How you transfer files from another system to your UNIX workstation depends on your TCP/IP product and your system's operating system. For more information about transferring files, refer to the documentation supplied with your TCP/IP product.

    IMPORTANT: Transfer the file in binary format. If you transfer the file in the wrong format, the installation will fail.

  3. On your UNIX server, access the downloaded tar file and extract it. For example, to extract the tar file for SequeLink Server for Oracle, you would enter:

    4. tar -xvof slora.tar

  4. If you logged on to your UNIX system as:
    • root, enter the following command:

      • ksh install.sh

    • Another user, enter the following command:

      • ksh install.sh -po

      When you run the installation script, it prompts you for choices you need to make and information you need to supply. Default answers to questions are enclosed within square brackets, [ ]. To accept the default, press ENTER.

Running the Installation Script

When you run the installation script, you will be prompted for choices you need to make and information you need to enter. Default answers to questions are enclosed in square brackets, [ ]. To accept the default value, press ENTER.

Follow Step 6 through Step 24 under "Installing on a Server with a DVD-ROM Drive" to complete the installation.

Uninstalling SequeLink® Server on Linux and UNIX

For information on using the SequeLink Manager Command-Line Tool (swcla), refer to the SequeLink Administrator's Guide.

  1. Start the SequeLink Manager Command-Line Tool by typing the following command; then, press ENTER:

    2. installdir/admin/swcla.sh

  2. Open the local configuration file by typing the following; then, press ENTER:

    3. aoc /installdir/cfg/swandm.ini

  3. List the SequeLink services by typing the following command; then, press ENTER:

    4. sl

  4. Stop each SequeLink Agent and database service that is running by typing the following command; then, press ENTER:

    5. sst service_name

    where service_name is the name of the service that you want to stop.

  5. Unregister each SequeLink Agent and database service by typing the following command; then, press ENTER:

    6. su service_name

    where service_name is the name of the service that you want to unregister.

  6. Delete each SequeLink Agent and database service by typing the following command; then, press ENTER:

    7. sd service_name

    where service_name is the name of the service that you want to delete.

  7. Exit swcla by typing the following; then, press ENTER:

    8. exit

  8. Delete the SequeLink installation directory.